package com.hzhr.iot.device.service;

import com.hzhr.iot.core.annotation.ApiImplicitInternalParams;
import com.hzhr.iot.core.exception.ServiceException;
import com.hzhr.iot.core.util.HzhrDateUtil;
import com.hzhr.iot.core.util.HzhrTypeUtil;
import com.hzhr.iot.device.constant.Device_ErrorsEnum;
import com.hzhr.iot.device.dao.mapper.custom.PengChunMapper;
import com.hzhr.iot.device.entity.*;
import com.hzhr.iot.device.entity.ext.AlarmDataEntityExt;
import com.hzhr.iot.device.model.regulatorDevice.RegulatorDeviceGetModel;
import com.hzhr.iot.device.model.regulatorDevice_monitor.RegulatorDevice_MonitorGetModel;
import com.hzhr.iot.device.model.regulatorDevice_monitor_alarmData.RegulatorDevice_Monitor_AlarmDataGetModel;
import com.hzhr.iot.device.model.regulatorDevice_monitor_alarmData.RegulatorDevice_Monitor_AlarmDataModel;
import com.hzhr.iot.device.service.base.BaseService;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import java.util.*;

@Service
public class RegulatorDevice_Monitor_AlarmDataService extends BaseService {
    @Autowired
    PengChunMapper pengChunMapper;

    //region javadoc注释 : get
    /**
     * 查询调压设备下的监控设备 <br/><br/>
     * 步骤 : <br/>
     * 1. 查询调压设备 : <br/>
     * 查询COLLECT_DEVICE对象regulator_1， <br/>
     * 查询规则如下： <br/>
     *           (1) COLLECT_DEVICE.ID == 路径参数regulatorDeviceId; <br/>
     *           (2) COLLECT_DEVICE.IS_VALID == '1'； <br/>
     * 如果regulator_1不存在，抛出异常201； <br/>
     * 2. 查询调压设备的下的监控设备 : <br/>
     * 查询IOT_DEVICE对象monitor_1, <br/>
     * 查询规则如下： <br/>
     *           (1) IOT_DEVICE.COLLECT_DEVICE_ID == regulator_1.ID; <br/>
     *           (2) IOT_DEVICE.ID = 路径参数monitorId; <br/>
     *           (3) IOT_DEVICE.IS_VALID == '1'; <br/>
     * 如果monitor_1不存在，抛出异常202； <br/>
     * 3. 查询监控设备的报警数据(按报警时间倒序排列) ： <br/>
     * 查询ALARM_DATA对象集合alarmDatas_1及总数， <br/>
     * 查询规则如下： <br/>
     *           (1) 条件参数的筛选条件; <br/>
     *           (2) ALARM_DATA.IOT_DEVICE_ID = monitor_1.ID; <br/>
     *           (3) ALARM_DATA.IS_VALID = '1'; <br/>
     * 4. 返回信息 <br/>
     * 根据条件参数、alarmDatas_1及总数生成RegulatorDevice_Monitor_AlarmDataGetModel对象result并返回， <br/>
     * RegulatorDevice_Monitor_AlarmDataModel与ALARM_DATA的对应关系如下： <br/>
     *           (1) RegulatorDevice_Monitor_AlarmDataModel.alarmTypeDes => ALARM_DATA.OPTIONS(关联字段：ALARM_TYPE).DES; <br/>
     *           (2) RegulatorDevice_Monitor_AlarmDataModel.currentTm => ALARM_DATA.CURRENT_TM; <br/>
     * @param header <br/>
     * _token : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 令牌;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-user-id : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 用户编号;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/>
     * _hzhr-user-code : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 用户代码;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-user-name : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 用户名;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-company-id : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 公司编号;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/>
     * _hzhr-dept-id : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 部门编号;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/>
     * _hzhr-user-type : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 用户类型(关联: common_service.options.code, typeCode = 'USER_TYPE');<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-transaction-id : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 交易流水号;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-transaction-type : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 交易类型;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : true;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _hzhr-access-mode : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 访问模式 0:一般 1:全局;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 默认值 : 0;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/><br/>
     * @param query <br/>
     * _show : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 展示形式 one:展示一个,list:展示列表,null(空值):不展示;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : string;<br/>
     * _show_total : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 是否展示总数;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 默认值 : false;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : boolean;<br/>
     * _page : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 页数;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 默认值 : 1;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/>
     * _count : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 每页数量;<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 默认值 : 1;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : int;<br/>
     * _greaterthanorequal_currentTm : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 筛选条件 : where ALARM_DATA.CURRENT_TM >= #{_greaterthanorequal_currentTm};<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : long;<br/>
     * _lessthan_currentTm : <br/>&nbsp&nbsp&nbsp&nbsp 说明 : 筛选条件 : where ALARM_DATA.CURRENT_TM < #{_lessthan_currentTm};<br/>&nbsp&nbsp&nbsp&nbsp 是否必填 : false;<br/>&nbsp&nbsp&nbsp&nbsp 数据类型 : long;<br/><br/>
     * @param regulatorDeviceId 调压设备编号 <br/><br/>
     * @param monitorId 监控设备编号 <br/><br/>
     * @throws ServiceException <br/>
     * REGULATORDEVICE_MONITOR_ALARMDATASERVICE_GET_201 : <br/>&nbsp&nbsp&nbsp&nbsp异常类型 : 业务流程异常<br/>&nbsp&nbsp&nbsp&nbsp异常业务 : 查询调压设备<br/>&nbsp&nbsp&nbsp&nbsp异常描述 : 调压设备不存在<br/>
     * REGULATORDEVICE_MONITOR_ALARMDATASERVICE_GET_202 : <br/>&nbsp&nbsp&nbsp&nbsp异常类型 : 业务流程异常<br/>&nbsp&nbsp&nbsp&nbsp异常业务 : 查询调压设备的下的监控设备<br/>&nbsp&nbsp&nbsp&nbsp异常描述 : 监控设备不存在<br/>
     * @see RegulatorDevice_Monitor_AlarmDataGetModel result <br/>
     */ 
    //endregion
    //region 说明 : get
    //查询调压设备下的监控设备
    //步骤 :
    //1. 查询调压设备 :
    //查询COLLECT_DEVICE对象regulator_1，
    //查询规则如下：
    //          (1) COLLECT_DEVICE.ID == 路径参数regulatorDeviceId;
    //          (2) COLLECT_DEVICE.IS_VALID == '1'；
    //如果regulator_1不存在，抛出异常201；
    //2. 查询调压设备的下的监控设备 :
    //查询IOT_DEVICE对象monitor_1,
    //查询规则如下：
    //          (1) IOT_DEVICE.COLLECT_DEVICE_ID == regulator_1.ID;
    //          (2) IOT_DEVICE.ID = 路径参数monitorId;
    //          (3) IOT_DEVICE.IS_VALID == '1';
    //如果monitor_1不存在，抛出异常202；
    //3. 查询监控设备的报警数据(按报警时间倒序排列) ：
    //查询ALARM_DATA对象集合alarmDatas_1及总数，
    //查询规则如下：
    //          (1) 条件参数的筛选条件;
    //          (2) ALARM_DATA.IOT_DEVICE_ID = monitor_1.ID;
    //          (3) ALARM_DATA.IS_VALID = '1';
    //4. 返回信息
    //根据条件参数、alarmDatas_1及总数生成RegulatorDevice_Monitor_AlarmDataGetModel对象result并返回，
    //RegulatorDevice_Monitor_AlarmDataModel与ALARM_DATA的对应关系如下：
    //          (1) RegulatorDevice_Monitor_AlarmDataModel.alarmTypeDes => ALARM_DATA.OPTIONS(关联字段：ALARM_TYPE).DES;
    //          (2) RegulatorDevice_Monitor_AlarmDataModel.currentTm => ALARM_DATA.CURRENT_TM;
    //endregion
    //region 参数 : get
    @ApiImplicitParams({
            @ApiImplicitParam(name = "token", value = "令牌",required = true, dataType = "string", paramType = "header"),

            @ApiImplicitParam(name = "regulatorDeviceId", value = "调压设备编号",required = true, dataType = "int", paramType = "path"),
            @ApiImplicitParam(name = "monitorId", value = "监控设备编号",required = true, dataType = "int", paramType = "path"),

            @ApiImplicitParam(name = "show", value = "展示形式 one:展示一个,list:展示列表,null(空值):不展示", required = false, dataType = "string", paramType = "query"),
            @ApiImplicitParam(name = "show_total", value = "是否展示总数", defaultValue = "false", required = false, dataType = "boolean", paramType = "query"),
            @ApiImplicitParam(name = "page", value = "页数", defaultValue = "1",required = false, dataType = "int", paramType = "query"),
            @ApiImplicitParam(name = "count", value = "每页数量", defaultValue = "1",required = false, dataType = "int", paramType = "query"),
            @ApiImplicitParam(name = "greaterthanorequal_currentTm", value = "筛选条件 : where RegulatorDevice_Monitor_AlarmDataModel.currentTm >= #{greaterthanorequal_currentTm}", required = false, dataType = "int", paramType = "query"),
            @ApiImplicitParam(name = "lessthan_currentTm", value = "筛选条件 : where RegulatorDevice_Monitor_AlarmDataModel.currentTm < #{lessthan_currentTm}", required = false, dataType = "int", paramType = "query"),

    })
    @ApiImplicitInternalParams({
            @ApiImplicitParam(name = "_token", value = "令牌",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-user-id", value = "用户编号",required = true, dataType = "int", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-user-code", value = "用户代码",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-user-name", value = "用户名",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-company-id", value = "公司编号",required = true, dataType = "int", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-dept-id", value = "部门编号",required = true, dataType = "int", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-user-type", value = "用户类型(关联: common_service.options.code, typeCode = 'USER_TYPE')",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-transaction-id", value = "交易流水号",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-transaction-type", value = "交易类型",required = true, dataType = "string", paramType = "header"),
            @ApiImplicitParam(name = "_hzhr-access-mode", value = "访问模式 0:一般 1:全局",defaultValue = "0", required = false, dataType = "int", paramType = "header"),

            @ApiImplicitParam(name = "_show", value = "展示形式 one:展示一个,list:展示列表,null(空值):不展示", required = false, dataType = "string", paramType = "query"),
            @ApiImplicitParam(name = "_show_total", value = "是否展示总数", defaultValue = "false", required = false, dataType = "boolean", paramType = "query"),
            @ApiImplicitParam(name = "_page", value = "页数", defaultValue = "1",required = false, dataType = "int", paramType = "query"),
            @ApiImplicitParam(name = "_count", value = "每页数量", defaultValue = "1",required = false, dataType = "int", paramType = "query"),
            @ApiImplicitParam(name = "_greaterthanorequal_currentTm", value = "筛选条件 : where ALARM_DATA.CURRENT_TM >= #{_greaterthanorequal_currentTm}", required = false, dataType = "long", paramType = "query"),
            @ApiImplicitParam(name = "_lessthan_currentTm", value = "筛选条件 : where ALARM_DATA.CURRENT_TM < #{_lessthan_currentTm}", required = false, dataType = "long", paramType = "query"),

    })
    //endregion
    //region 请求 : get
       @RequestMapping(value = "/regulator-devices/{regulatorDeviceId}/monitors/{monitorId}/alarm-datas", method = RequestMethod.GET)
    //endregion
    public RegulatorDevice_Monitor_AlarmDataGetModel get(Map<String, String> header, Integer regulatorDeviceId,
                                                         Integer monitorId, Map<String, Object> query) throws ServiceException {
        //1. 查询调压设备 :
        //查询COLLECT_DEVICE对象regulator_1，
        //查询规则如下：
        //          (1) COLLECT_DEVICE.ID == 路径参数regulatorDeviceId;
        //          (2) COLLECT_DEVICE.IS_VALID == '1'；
        //如果regulator_1不存在，抛出异常201；
        CollectDeviceEntity regulator_1 = pengChunMapper.select1(regulatorDeviceId);
        if (regulator_1 == null) {
            throw new ServiceException(Device_ErrorsEnum.REGULATORDEVICE_MONITOR_ALARMDATASERVICE_GET_201);
        }

        //2. 查询调压设备的下的监控设备 :
        //查询IOT_DEVICE对象monitor_1,
        //查询规则如下：
        //          (1) IOT_DEVICE.COLLECT_DEVICE_ID == regulator_1.ID;
        //          (2) IOT_DEVICE.ID = 路径参数monitorId;
        //          (3) IOT_DEVICE.IS_VALID == '1';
        Integer regulatorId_1 = regulator_1.getId();
        IotDeviceEntity monitor_1 = pengChunMapper.select2(monitorId, regulatorId_1);
        if (monitor_1 == null) {
            throw new ServiceException(Device_ErrorsEnum.REGULATORDEVICE_MONITOR_ALARMDATASERVICE_GET_202);
        }

        //3. 查询监控设备的报警数据 ：
        //查询ALARM_DATA对象集合alarmDatas_1及总数，
        //查询规则如下：
        //          (1) 条件参数的筛选条件;
        //          (2) ALARM_DATA.IOT_DEVICE_ID = monitor_1.ID;
        //          (3) ALARM_DATA.IS_VALID = '1';
        String _show = HzhrTypeUtil.object2string(query.get("_show"));
        Boolean _show_total = HzhrTypeUtil.object2boolean(query.get("_show_total"));
        Integer _page = HzhrTypeUtil.object2integer(query.get("_page"));
        Integer _count = HzhrTypeUtil.object2integer(query.get("_count"));
        Integer start = null;
        if (_page != null && _count != null && _page > 0 && _count > 0) {
            start = (_page - 1) * _count;
        }
        Long _greaterthanorequal_currentTm = HzhrTypeUtil.object2long(query.get("_greaterthanorequal_currentTm"));
        Date date1 = null;
        if (_greaterthanorequal_currentTm != null) {
            date1 = new Date(_greaterthanorequal_currentTm);
        }
        String dateStr1 = null;
        if (date1 != null) {
            dateStr1 = HzhrDateUtil.dateToStr(date1);
        }
        Long _lessthan_currentTm = HzhrTypeUtil.object2long(query.get("_lessthan_currentTm"));
        Date date2 = null;
        if (_lessthan_currentTm != null) {
            date2 = new Date(_lessthan_currentTm);
        }
        String dateStr2 = null;
        if (date2 != null) {
            dateStr2 = HzhrDateUtil.dateToStr(date2);
        }
        List<AlarmDataEntityExt> alarmDatas_1 = null;
        if (_show != null) {
            alarmDatas_1 = pengChunMapper.select3(start, _count, dateStr1, dateStr2, monitor_1.getId());
        }
        Integer total = null;
        if (_show_total != null && _show_total) {
            total = pengChunMapper.select4(dateStr1, dateStr2, monitor_1.getId());
        }

        //4. 返回信息
        //根据条件参数、alarmDatas_1及总数生成RegulatorDevice_Monitor_AlarmDataGetModel对象result并返回，
        //RegulatorDevice_Monitor_AlarmDataModel与ALARM_DATA的对应关系如下：
        //          (1) RegulatorDevice_Monitor_AlarmDataModel.alarmTypeDes => ALARM_DATA.OPTIONS(关联字段：ALARM_TYPE).DES;
        //          (2) RegulatorDevice_Monitor_AlarmDataModel.currentTm => ALARM_DATA.CURRENT_TM;
        RegulatorDevice_Monitor_AlarmDataGetModel result = new RegulatorDevice_Monitor_AlarmDataGetModel();
        if ("one".equals(_show)) {
            if (alarmDatas_1 != null && alarmDatas_1.size() > 0) {
                AlarmDataEntityExt alarmDataEntityExt = alarmDatas_1.get(0);
                RegulatorDevice_Monitor_AlarmDataModel regulatorDevice_monitor_alarmDataModel = new RegulatorDevice_Monitor_AlarmDataModel();
                OptionsEntity entity1 = alarmDataEntityExt.getEntity1();
                if (entity1 != null) {
                    regulatorDevice_monitor_alarmDataModel.setAlarmTypeDes(entity1.getDes());
                }
                Date currentTm = alarmDataEntityExt.getCurrentTm();
                if (currentTm != null) {
                    regulatorDevice_monitor_alarmDataModel.setCurrentTm(currentTm.getTime());
                }
                result.setModel(regulatorDevice_monitor_alarmDataModel);
            }
        }
        if ("list".equals(_show)) {
            if (alarmDatas_1 != null) {
                List<RegulatorDevice_Monitor_AlarmDataModel> regulatorDevice_monitor_alarmDataModels = new ArrayList<>();
                for (AlarmDataEntityExt alarmDataEntityExt :
                        alarmDatas_1) {
                    RegulatorDevice_Monitor_AlarmDataModel regulatorDevice_monitor_alarmDataModel = new RegulatorDevice_Monitor_AlarmDataModel();
                    OptionsEntity entity1 = alarmDataEntityExt.getEntity1();
                    if (entity1 != null) {
                        regulatorDevice_monitor_alarmDataModel.setAlarmTypeDes(entity1.getDes());
                    }
                    Date currentTm = alarmDataEntityExt.getCurrentTm();
                    if (currentTm != null) {
                        regulatorDevice_monitor_alarmDataModel.setCurrentTm(currentTm.getTime());
                    }
                    regulatorDevice_monitor_alarmDataModels.add(regulatorDevice_monitor_alarmDataModel);
                }
                result.setModelList(regulatorDevice_monitor_alarmDataModels);
            }
        }
        result.setTotal(total);
        return result;
    }
}

